-- create
CREATE SEQUENCE devschema.seq_languages 
AS BIGINT 
START WITH 1 
INCREMENT BY 1
MINVALUE 1;

-- delete
DROP SEQUENCE devschema.seq_languages RESTRICT;

-- nextval
VALUES (NEXT VALUE FOR devschema.seq_languages);

-- in my knowledge there is no way to get a currval in derby

-- how to check sequence existence since jdbc does not have a metadata for them.
-- not all databases support them so they are not part on the jdbc standard
SELECT COUNT(0) AS COUNT FROM SYS.SYSSEQUENCES WHERE SEQUENCENAME='SEQ_LANGUAGES'
